Let's start answering the questions asked

1. Total revenue current year

Revenue for the year  2017  is: $31417495

2. New Customer revenue

New customer revenue for customers who joined in 2016 and not in 2015 and who joined in 2017 and were not in 2016 is:
 $ 38975579.91

3. Existing customer growth

The Existing customer growth if we compare the 2017 existing customer growth and 2016 existing customer growth: $ 1123705.33

4. Revenue lost from attrition

Revenue lost due to attrition: $ 36697734.78

5. Existing customer revenue current year

Existing Customer Revenue for current year 2017 : $ 9648282.02

6. Existing Customer Revenue Prior Year

Existing Customer Revenue for prior year 2016: $ 8524576.69

7. Total Customers Current Year

Total customers current year 2017 is :  249987

8. Total Customers Previous year

Total customers previous year 2016 is :  204646

9. New Customers

Total new customers gained in year 2016 and 2017 : 310340

10. Lost Customers

Total customers lost that were in 2015 and not in 2016 and with the company in 2016 and not in 2017 :  291647

Visualization

Here, we can see the pattern that 2016 was not a good year for the company as we had drop in revenue due to drop in number of customers

Above, for the year 2015, we would consider all customers as new customer. Here, we can see that almost same number of customers stayed in 2016 and 2017, but in 2017, more customers were added.